﻿CREATE TABLE [dbo].[tblSubKategorie] (
    [SubKategorieID]   INT          NOT NULL,
    [SubKategorieName] VARCHAR (31) NOT NULL,
    [KategorieID]      INT          NOT NULL,
    CONSTRAINT [PK_tblSubKategorie] PRIMARY KEY CLUSTERED ([SubKategorieID] ASC),
    CONSTRAINT [FK_tblSubKategorie_tblKategorie] FOREIGN KEY ([KategorieID]) REFERENCES [dbo].[tblKategorie] ([KategorieID])
);

